Dataset statistics
| Number of variables | 32 |
|---|---|
| Number of observations | 141947 |
| Missing cells | 154010 |
| Missing cells (%) | 3.4% |
| Duplicate rows | 10164 |
| Duplicate rows (%) | 7.2% |
| Total size in memory | 34.7 MiB |
| Average record size in memory | 256.0 B |
Variable types
| Categorical | 18 |
|---|---|
| Numeric | 14 |
| Dataset has 10164 (7.2%) duplicate rows | Duplicates |
country has a high cardinality: 177 distinct values | High cardinality |
reservation_status_date has a high cardinality: 925 distinct values | High cardinality |
arrival_date_week_number is highly overall correlated with arrival_date_month | High correlation |
agent is highly overall correlated with hotel | High correlation |
company is highly overall correlated with hotel | High correlation |
hotel is highly overall correlated with agent and 1 other fields | High correlation |
is_canceled is highly overall correlated with reservation_status | High correlation |
arrival_date_month is highly overall correlated with arrival_date_week_number | High correlation |
market_segment is highly overall correlated with distribution_channel | High correlation |
distribution_channel is highly overall correlated with market_segment | High correlation |
reserved_room_type is highly overall correlated with assigned_room_type | High correlation |
assigned_room_type is highly overall correlated with reserved_room_type | High correlation |
reservation_status is highly overall correlated with is_canceled | High correlation |
children is highly imbalanced (81.6%) | Imbalance |
babies is highly imbalanced (97.1%) | Imbalance |
meal is highly imbalanced (53.5%) | Imbalance |
country is highly imbalanced (54.9%) | Imbalance |
distribution_channel is highly imbalanced (62.9%) | Imbalance |
is_repeated_guest is highly imbalanced (79.9%) | Imbalance |
reserved_room_type is highly imbalanced (59.4%) | Imbalance |
assigned_room_type is highly imbalanced (51.7%) | Imbalance |
deposit_type is highly imbalanced (64.1%) | Imbalance |
required_car_parking_spaces is highly imbalanced (85.5%) | Imbalance |
agent has 19555 (13.8%) missing values | Missing |
company has 133822 (94.3%) missing values | Missing |
adults is highly skewed (γ1 = 24.26609101) | Skewed |
previous_cancellations is highly skewed (γ1 = 20.2286875) | Skewed |
previous_bookings_not_canceled is highly skewed (γ1 = 25.29075503) | Skewed |
lead_time has 7861 (5.5%) zeros | Zeros |
stays_in_weekend_nights has 62065 (43.7%) zeros | Zeros |
stays_in_week_nights has 8881 (6.3%) zeros | Zeros |
previous_cancellations has 131027 (92.3%) zeros | Zeros |
previous_bookings_not_canceled has 138008 (97.2%) zeros | Zeros |
booking_changes has 120861 (85.1%) zeros | Zeros |
days_in_waiting_list has 137500 (96.9%) zeros | Zeros |
adr has 2555 (1.8%) zeros | Zeros |
total_of_special_requests has 86024 (60.6%) zeros | Zeros |
Reproduction
| Analysis started | 2023-04-04 14:49:04.796641 |
|---|---|
| Analysis finished | 2023-04-04 14:51:38.390228 |
| Duration | 2 minutes and 33.59 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
hotel
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| City Hotel | |
|---|---|
| Resort Hotel |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 10.688201 |
| Min length | 10 |
Characters and Unicode
| Total characters | 1517158 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Resort Hotel |
|---|---|
| 2nd row | Resort Hotel |
| 3rd row | Resort Hotel |
| 4th row | Resort Hotel |
| 5th row | Resort Hotel |
Common Values
| Value | Count | Frequency (%) |
| City Hotel | 93103 | |
| Resort Hotel | 48844 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| hotel | 141947 | |
| city | 93103 | |
| resort | 48844 | 17.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 283894 | |
| o | 190791 | |
| e | 190791 | |
| 141947 | ||
| H | 141947 | |
| l | 141947 | |
| C | 93103 | 6.1% |
| i | 93103 | 6.1% |
| y | 93103 | 6.1% |
| R | 48844 | 3.2% |
| Other values (2) | 97688 | 6.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1091317 | |
| Uppercase Letter | 283894 | 18.7% |
| Space Separator | 141947 | 9.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 283894 | |
| o | 190791 | |
| e | 190791 | |
| l | 141947 | |
| i | 93103 | 8.5% |
| y | 93103 | 8.5% |
| s | 48844 | 4.5% |
| r | 48844 | 4.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| H | 141947 | |
| C | 93103 | |
| R | 48844 | 17.2% |
Space Separator
| Value | Count | Frequency (%) |
| 141947 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1375211 | |
| Common | 141947 | 9.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 283894 | |
| o | 190791 | |
| e | 190791 | |
| H | 141947 | |
| l | 141947 | |
| C | 93103 | 6.8% |
| i | 93103 | 6.8% |
| y | 93103 | 6.8% |
| R | 48844 | 3.6% |
| s | 48844 | 3.6% |
Common
| Value | Count | Frequency (%) |
| 141947 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1517158 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 283894 | |
| o | 190791 | |
| e | 190791 | |
| 141947 | ||
| H | 141947 | |
| l | 141947 | |
| C | 93103 | 6.1% |
| i | 93103 | 6.1% |
| y | 93103 | 6.1% |
| R | 48844 | 3.2% |
| Other values (2) | 97688 | 6.4% |
is_canceled
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 141947 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 89108 | |
| 1 | 52839 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 89108 | |
| 1 | 52839 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 89108 | |
| 1 | 52839 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 141947 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 89108 | |
| 1 | 52839 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 141947 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 89108 | |
| 1 | 52839 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 141947 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 89108 | |
| 1 | 52839 |
lead_time
Real number (ℝ)
| Distinct | 479 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 102.8211 |
| Minimum | 0 |
|---|---|
| Maximum | 737 |
| Zeros | 7861 |
| Zeros (%) | 5.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 17 |
| median | 68 |
| Q3 | 158 |
| 95-th percentile | 320 |
| Maximum | 737 |
| Range | 737 |
| Interquartile range (IQR) | 141 |
Descriptive statistics
| Standard deviation | 106.47857 |
|---|---|
| Coefficient of variation (CV) | 1.0355712 |
| Kurtosis | 1.483849 |
| Mean | 102.8211 |
| Median Absolute Deviation (MAD) | 59 |
| Skewness | 1.3180998 |
| Sum | 14595147 |
| Variance | 11337.686 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 7861 | 5.5% |
| 1 | 4153 | 2.9% |
| 2 | 2453 | 1.7% |
| 3 | 2193 | 1.5% |
| 4 | 2033 | 1.4% |
| 5 | 1926 | 1.4% |
| 6 | 1756 | 1.2% |
| 7 | 1553 | 1.1% |
| 8 | 1376 | 1.0% |
| 12 | 1358 | 1.0% |
| Other values (469) | 115285 |
| Value | Count | Frequency (%) |
| 0 | 7861 | |
| 1 | 4153 | |
| 2 | 2453 | 1.7% |
| 3 | 2193 | 1.5% |
| 4 | 2033 | 1.4% |
| 5 | 1926 | 1.4% |
| 6 | 1756 | 1.2% |
| 7 | 1553 | 1.1% |
| 8 | 1376 | 1.0% |
| 9 | 1146 | 0.8% |
| Value | Count | Frequency (%) |
| 737 | 2 | < 0.1% |
| 709 | 1 | < 0.1% |
| 629 | 17 | |
| 626 | 30 | |
| 622 | 17 | |
| 615 | 17 | |
| 608 | 17 | |
| 605 | 30 | |
| 601 | 17 | |
| 594 | 17 |
arrival_date_year
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 2019 | |
|---|---|
| 2020 | |
| 2018 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 567788 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2018 |
|---|---|
| 2nd row | 2018 |
| 3rd row | 2018 |
| 4th row | 2018 |
| 5th row | 2018 |
Common Values
| Value | Count | Frequency (%) |
| 2019 | 79264 | |
| 2020 | 40687 | |
| 2018 | 21996 | 15.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2019 | 79264 | |
| 2020 | 40687 | |
| 2018 | 21996 | 15.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 182634 | |
| 0 | 182634 | |
| 1 | 101260 | |
| 9 | 79264 | |
| 8 | 21996 | 3.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 567788 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 182634 | |
| 0 | 182634 | |
| 1 | 101260 | |
| 9 | 79264 | |
| 8 | 21996 | 3.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 567788 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 182634 | |
| 0 | 182634 | |
| 1 | 101260 | |
| 9 | 79264 | |
| 8 | 21996 | 3.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 567788 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 182634 | |
| 0 | 182634 | |
| 1 | 101260 | |
| 9 | 79264 | |
| 8 | 21996 | 3.9% |
arrival_date_month
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| August | |
|---|---|
| October | |
| September | |
| July | |
| May | |
| Other values (7) |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 6.1032146 |
| Min length | 3 |
Characters and Unicode
| Total characters | 866333 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | July |
|---|---|
| 2nd row | July |
| 3rd row | July |
| 4th row | July |
| 5th row | July |
Common Values
| Value | Count | Frequency (%) |
| August | 17772 | |
| October | 16127 | |
| September | 15630 | |
| July | 15446 | |
| May | 11791 | |
| April | 11089 | |
| June | 10939 | |
| December | 9812 | |
| March | 9810 | |
| November | 9149 | |
| Other values (2) | 14382 |
Length
| Value | Count | Frequency (%) |
| august | 17772 | |
| october | 16127 | |
| september | 15630 | |
| july | 15446 | |
| may | 11791 | |
| april | 11089 | |
| june | 10939 | |
| december | 9812 | |
| march | 9810 | |
| november | 9149 | |
| Other values (2) | 14382 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 130062 | |
| r | 94371 | 10.9% |
| u | 76311 | 8.8% |
| b | 59090 | 6.8% |
| t | 49529 | 5.7% |
| a | 41993 | 4.8% |
| y | 41619 | 4.8% |
| c | 35749 | 4.1% |
| m | 34591 | 4.0% |
| J | 32395 | 3.7% |
| Other values (16) | 270623 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 724386 | |
| Uppercase Letter | 141947 | 16.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 130062 | |
| r | 94371 | |
| u | 76311 | |
| b | 59090 | |
| t | 49529 | 6.8% |
| a | 41993 | 5.8% |
| y | 41619 | 5.7% |
| c | 35749 | 4.9% |
| m | 34591 | 4.8% |
| p | 26719 | 3.7% |
| Other values (8) | 134352 |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 32395 | |
| A | 28861 | |
| M | 21601 | |
| O | 16127 | |
| S | 15630 | |
| D | 9812 | 6.9% |
| N | 9149 | 6.4% |
| F | 8372 | 5.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 866333 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 130062 | |
| r | 94371 | 10.9% |
| u | 76311 | 8.8% |
| b | 59090 | 6.8% |
| t | 49529 | 5.7% |
| a | 41993 | 4.8% |
| y | 41619 | 4.8% |
| c | 35749 | 4.1% |
| m | 34591 | 4.0% |
| J | 32395 | 3.7% |
| Other values (16) | 270623 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 866333 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 130062 | |
| r | 94371 | 10.9% |
| u | 76311 | 8.8% |
| b | 59090 | 6.8% |
| t | 49529 | 5.7% |
| a | 41993 | 4.8% |
| y | 41619 | 4.8% |
| c | 35749 | 4.1% |
| m | 34591 | 4.0% |
| J | 32395 | 3.7% |
| Other values (16) | 270623 |
arrival_date_week_number
Real number (ℝ)
| Distinct | 53 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 29.061058 |
| Minimum | 1 |
|---|---|
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 18 |
| median | 30 |
| Q3 | 40 |
| 95-th percentile | 50 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 13.604758 |
|---|---|
| Coefficient of variation (CV) | 0.46814392 |
| Kurtosis | -0.94553904 |
| Mean | 29.061058 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | -0.20504069 |
| Sum | 4125130 |
| Variance | 185.08943 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 33 | 4750 | 3.3% |
| 41 | 4102 | 2.9% |
| 38 | 4033 | 2.8% |
| 42 | 3979 | 2.8% |
| 32 | 3898 | 2.7% |
| 39 | 3886 | 2.7% |
| 30 | 3857 | 2.7% |
| 34 | 3811 | 2.7% |
| 29 | 3461 | 2.4% |
| 40 | 3427 | 2.4% |
| Other values (43) | 102743 |
| Value | Count | Frequency (%) |
| 1 | 1059 | |
| 2 | 1251 | |
| 3 | 1330 | |
| 4 | 1498 | |
| 5 | 1400 | |
| 6 | 1562 | |
| 7 | 2250 | |
| 8 | 2244 | |
| 9 | 2190 | |
| 10 | 2174 |
| Value | Count | Frequency (%) |
| 53 | 2636 | |
| 52 | 1708 | |
| 51 | 1249 | 0.9% |
| 50 | 2117 | |
| 49 | 2629 | |
| 48 | 2121 | |
| 47 | 2371 | |
| 46 | 1999 | |
| 45 | 2492 | |
| 44 | 3139 |
arrival_date_day_of_month
Real number (ℝ)
| Distinct | 30 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.74897 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.7373137 |
|---|---|
| Coefficient of variation (CV) | 0.55478637 |
| Kurtosis | -1.1937217 |
| Mean | 15.74897 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | -0.0050601603 |
| Sum | 2235519 |
| Variance | 76.340651 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 28 | 8663 | 6.1% |
| 5 | 5506 | 3.9% |
| 17 | 5343 | 3.8% |
| 25 | 5049 | 3.6% |
| 18 | 4931 | 3.5% |
| 15 | 4931 | 3.5% |
| 9 | 4926 | 3.5% |
| 16 | 4924 | 3.5% |
| 12 | 4894 | 3.4% |
| 26 | 4825 | 3.4% |
| Other values (20) | 87955 |
| Value | Count | Frequency (%) |
| 1 | 4216 | |
| 2 | 4686 | |
| 3 | 4622 | |
| 4 | 4487 | |
| 5 | 5506 | |
| 6 | 4512 | |
| 7 | 4319 | |
| 8 | 4727 | |
| 9 | 4926 | |
| 10 | 4358 |
| Value | Count | Frequency (%) |
| 31 | 2738 | 1.9% |
| 30 | 4690 | |
| 28 | 8663 | |
| 27 | 4473 | |
| 26 | 4825 | |
| 25 | 5049 | |
| 24 | 4751 | |
| 23 | 4360 | |
| 22 | 4170 | |
| 21 | 4410 |
stays_in_weekend_nights
Real number (ℝ)
| Distinct | 17 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.92755747 |
| Minimum | 0 |
|---|---|
| Maximum | 19 |
| Zeros | 62065 |
| Zeros (%) | 43.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 19 |
| Range | 19 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.0008171 |
|---|---|
| Coefficient of variation (CV) | 1.0789813 |
| Kurtosis | 7.2352028 |
| Mean | 0.92755747 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.3822691 |
| Sum | 131664 |
| Variance | 1.0016349 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 62065 | |
| 2 | 39780 | |
| 1 | 35967 | |
| 4 | 2212 | 1.6% |
| 3 | 1514 | 1.1% |
| 6 | 167 | 0.1% |
| 5 | 100 | 0.1% |
| 8 | 71 | 0.1% |
| 7 | 31 | < 0.1% |
| 9 | 15 | < 0.1% |
| Other values (7) | 25 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 62065 | |
| 1 | 35967 | |
| 2 | 39780 | |
| 3 | 1514 | 1.1% |
| 4 | 2212 | 1.6% |
| 5 | 100 | 0.1% |
| 6 | 167 | 0.1% |
| 7 | 31 | < 0.1% |
| 8 | 71 | 0.1% |
| 9 | 15 | < 0.1% |
| Value | Count | Frequency (%) |
| 19 | 1 | < 0.1% |
| 18 | 2 | < 0.1% |
| 16 | 3 | < 0.1% |
| 14 | 2 | < 0.1% |
| 13 | 4 | < 0.1% |
| 12 | 6 | < 0.1% |
| 10 | 7 | < 0.1% |
| 9 | 15 | < 0.1% |
| 8 | 71 | |
| 7 | 31 |
stays_in_week_nights
Real number (ℝ)
| Distinct | 35 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4955089 |
| Minimum | 0 |
|---|---|
| Maximum | 50 |
| Zeros | 8881 |
| Zeros (%) | 6.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 50 |
| Range | 50 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.9097836 |
|---|---|
| Coefficient of variation (CV) | 0.76528825 |
| Kurtosis | 24.026218 |
| Mean | 2.4955089 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.8594249 |
| Sum | 354230 |
| Variance | 3.6472735 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 40810 | |
| 1 | 36419 | |
| 3 | 25612 | |
| 5 | 13113 | 9.2% |
| 4 | 11209 | 7.9% |
| 0 | 8881 | 6.3% |
| 6 | 1857 | 1.3% |
| 10 | 1252 | 0.9% |
| 7 | 1248 | 0.9% |
| 8 | 789 | 0.6% |
| Other values (25) | 757 | 0.5% |
| Value | Count | Frequency (%) |
| 0 | 8881 | 6.3% |
| 1 | 36419 | |
| 2 | 40810 | |
| 3 | 25612 | |
| 4 | 11209 | 7.9% |
| 5 | 13113 | 9.2% |
| 6 | 1857 | 1.3% |
| 7 | 1248 | 0.9% |
| 8 | 789 | 0.6% |
| 9 | 279 | 0.2% |
| Value | Count | Frequency (%) |
| 50 | 1 | < 0.1% |
| 42 | 2 | < 0.1% |
| 41 | 1 | < 0.1% |
| 40 | 2 | < 0.1% |
| 35 | 1 | < 0.1% |
| 34 | 1 | < 0.1% |
| 33 | 2 | < 0.1% |
| 32 | 1 | < 0.1% |
| 30 | 6 | |
| 26 | 1 | < 0.1% |
adults
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.8525506 |
| Minimum | 0 |
|---|---|
| Maximum | 55 |
| Zeros | 448 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 55 |
| Range | 55 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.6285531 |
|---|---|
| Coefficient of variation (CV) | 0.33929065 |
| Kurtosis | 1640.728 |
| Mean | 1.8525506 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 24.266091 |
| Sum | 262964 |
| Variance | 0.395079 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 107169 | |
| 1 | 27564 | 19.4% |
| 3 | 6664 | 4.7% |
| 0 | 448 | 0.3% |
| 4 | 70 | < 0.1% |
| 26 | 10 | < 0.1% |
| 27 | 4 | < 0.1% |
| 20 | 4 | < 0.1% |
| 5 | 4 | < 0.1% |
| 40 | 2 | < 0.1% |
| Other values (4) | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 448 | 0.3% |
| 1 | 27564 | 19.4% |
| 2 | 107169 | |
| 3 | 6664 | 4.7% |
| 4 | 70 | < 0.1% |
| 5 | 4 | < 0.1% |
| 6 | 2 | < 0.1% |
| 10 | 2 | < 0.1% |
| 20 | 4 | < 0.1% |
| 26 | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 55 | 2 | < 0.1% |
| 50 | 2 | < 0.1% |
| 40 | 2 | < 0.1% |
| 27 | 4 | < 0.1% |
| 26 | 10 | < 0.1% |
| 20 | 4 | < 0.1% |
| 10 | 2 | < 0.1% |
| 6 | 2 | < 0.1% |
| 5 | 4 | < 0.1% |
| 4 | 70 |
children
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 8 |
| Missing (%) | < 0.1% |
| Memory size | 1.1 MiB |
| 0.0 | |
|---|---|
| 1.0 | 5358 |
| 2.0 | 4097 |
| 3.0 | 81 |
| 10.0 | 3 |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.0000211 |
| Min length | 3 |
Characters and Unicode
| Total characters | 425820 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 132400 | |
| 1.0 | 5358 | 3.8% |
| 2.0 | 4097 | 2.9% |
| 3.0 | 81 | 0.1% |
| 10.0 | 3 | < 0.1% |
| (Missing) | 8 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 132400 | |
| 1.0 | 5358 | 3.8% |
| 2.0 | 4097 | 2.9% |
| 3.0 | 81 | 0.1% |
| 10.0 | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 274342 | |
| . | 141939 | |
| 1 | 5361 | 1.3% |
| 2 | 4097 | 1.0% |
| 3 | 81 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 283881 | |
| Other Punctuation | 141939 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 274342 | |
| 1 | 5361 | 1.9% |
| 2 | 4097 | 1.4% |
| 3 | 81 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 141939 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 425820 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 274342 | |
| . | 141939 | |
| 1 | 5361 | 1.3% |
| 2 | 4097 | 1.0% |
| 3 | 81 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 425820 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 274342 | |
| . | 141939 | |
| 1 | 5361 | 1.3% |
| 2 | 4097 | 1.0% |
| 3 | 81 | < 0.1% |
babies
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 | 1114 |
| 2 | 17 |
| 9 | 2 |
| 10 | 1 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.000007 |
| Min length | 1 |
Characters and Unicode
| Total characters | 141948 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 140813 | |
| 1 | 1114 | 0.8% |
| 2 | 17 | < 0.1% |
| 9 | 2 | < 0.1% |
| 10 | 1 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 140813 | |
| 1 | 1114 | 0.8% |
| 2 | 17 | < 0.1% |
| 9 | 2 | < 0.1% |
| 10 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 140814 | |
| 1 | 1115 | 0.8% |
| 2 | 17 | < 0.1% |
| 9 | 2 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 141948 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 140814 | |
| 1 | 1115 | 0.8% |
| 2 | 17 | < 0.1% |
| 9 | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 141948 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 140814 | |
| 1 | 1115 | 0.8% |
| 2 | 17 | < 0.1% |
| 9 | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 141948 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 140814 | |
| 1 | 1115 | 0.8% |
| 2 | 17 | < 0.1% |
| 9 | 2 | < 0.1% |
meal
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| BB | |
|---|---|
| HB | |
| SC | |
| Undefined | 1372 |
| FB | 1228 |
Length
| Max length | 9 |
|---|---|
| Median length | 2 |
| Mean length | 2.0676591 |
| Min length | 2 |
Characters and Unicode
| Total characters | 293498 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BB |
|---|---|
| 2nd row | HB |
| 3rd row | BB |
| 4th row | BB |
| 5th row | BB |
Common Values
| Value | Count | Frequency (%) |
| BB | 109878 | |
| HB | 18402 | 13.0% |
| SC | 11067 | 7.8% |
| Undefined | 1372 | 1.0% |
| FB | 1228 | 0.9% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| bb | 109878 | |
| hb | 18402 | 13.0% |
| sc | 11067 | 7.8% |
| undefined | 1372 | 1.0% |
| fb | 1228 | 0.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 239386 | |
| H | 18402 | 6.3% |
| S | 11067 | 3.8% |
| C | 11067 | 3.8% |
| n | 2744 | 0.9% |
| d | 2744 | 0.9% |
| e | 2744 | 0.9% |
| U | 1372 | 0.5% |
| f | 1372 | 0.5% |
| i | 1372 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 282522 | |
| Lowercase Letter | 10976 | 3.7% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 239386 | |
| H | 18402 | 6.5% |
| S | 11067 | 3.9% |
| C | 11067 | 3.9% |
| U | 1372 | 0.5% |
| F | 1228 | 0.4% |
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 2744 | |
| d | 2744 | |
| e | 2744 | |
| f | 1372 | |
| i | 1372 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 293498 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| B | 239386 | |
| H | 18402 | 6.3% |
| S | 11067 | 3.8% |
| C | 11067 | 3.8% |
| n | 2744 | 0.9% |
| d | 2744 | 0.9% |
| e | 2744 | 0.9% |
| U | 1372 | 0.5% |
| f | 1372 | 0.5% |
| i | 1372 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 293498 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| B | 239386 | |
| H | 18402 | 6.3% |
| S | 11067 | 3.8% |
| C | 11067 | 3.8% |
| n | 2744 | 0.9% |
| d | 2744 | 0.9% |
| e | 2744 | 0.9% |
| U | 1372 | 0.5% |
| f | 1372 | 0.5% |
| i | 1372 | 0.5% |
country
Categorical
HIGH CARDINALITY  IMBALANCE 
| Distinct | 177 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 625 |
| Missing (%) | 0.4% |
| Memory size | 1.1 MiB |
| PRT | |
|---|---|
| GBR | |
| FRA | |
| ESP | |
| DEU | |
| Other values (172) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.9900086 |
| Min length | 2 |
Characters and Unicode
| Total characters | 422554 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 26 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PRT |
|---|---|
| 2nd row | PRT |
| 3rd row | PRT |
| 4th row | PRT |
| 5th row | PRT |
Common Values
| Value | Count | Frequency (%) |
| PRT | 62384 | |
| GBR | 13487 | 9.5% |
| FRA | 11792 | 8.3% |
| ESP | 10519 | 7.4% |
| DEU | 7813 | 5.5% |
| ITA | 4321 | 3.0% |
| IRL | 3860 | 2.7% |
| BEL | 2554 | 1.8% |
| BRA | 2374 | 1.7% |
| NLD | 2304 | 1.6% |
| Other values (167) | 19914 | 14.0% |
Length
| Value | Count | Frequency (%) |
| prt | 62384 | |
| gbr | 13487 | 9.5% |
| fra | 11792 | 8.3% |
| esp | 10519 | 7.4% |
| deu | 7813 | 5.5% |
| ita | 4321 | 3.1% |
| irl | 3860 | 2.7% |
| bel | 2554 | 1.8% |
| bra | 2374 | 1.7% |
| nld | 2304 | 1.6% |
| Other values (167) | 19914 | 14.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 98468 | |
| P | 74386 | |
| T | 68782 | |
| E | 24565 | 5.8% |
| A | 24172 | 5.7% |
| B | 18803 | 4.4% |
| S | 16484 | 3.9% |
| G | 14598 | 3.5% |
| U | 14401 | 3.4% |
| F | 12379 | 2.9% |
| Other values (16) | 55516 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 422554 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 98468 | |
| P | 74386 | |
| T | 68782 | |
| E | 24565 | 5.8% |
| A | 24172 | 5.7% |
| B | 18803 | 4.4% |
| S | 16484 | 3.9% |
| G | 14598 | 3.5% |
| U | 14401 | 3.4% |
| F | 12379 | 2.9% |
| Other values (16) | 55516 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 422554 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 98468 | |
| P | 74386 | |
| T | 68782 | |
| E | 24565 | 5.8% |
| A | 24172 | 5.7% |
| B | 18803 | 4.4% |
| S | 16484 | 3.9% |
| G | 14598 | 3.5% |
| U | 14401 | 3.4% |
| F | 12379 | 2.9% |
| Other values (16) | 55516 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 422554 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 98468 | |
| P | 74386 | |
| T | 68782 | |
| E | 24565 | 5.8% |
| A | 24172 | 5.7% |
| B | 18803 | 4.4% |
| S | 16484 | 3.9% |
| G | 14598 | 3.5% |
| U | 14401 | 3.4% |
| F | 12379 | 2.9% |
| Other values (16) | 55516 |
market_segment
Categorical
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Online TA | |
|---|---|
| Offline TA/TO | |
| Groups | |
| Direct | |
| Corporate | |
| Other values (3) | 1154 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 9.0117438 |
| Min length | 6 |
Characters and Unicode
| Total characters | 1279190 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Online TA |
|---|---|
| 2nd row | Offline TA/TO |
| 3rd row | Online TA |
| 4th row | Online TA |
| 5th row | Direct |
Common Values
| Value | Count | Frequency (%) |
| Online TA | 62840 | |
| Offline TA/TO | 30379 | |
| Groups | 26115 | |
| Direct | 14973 | 10.5% |
| Corporate | 6486 | 4.6% |
| Complementary | 913 | 0.6% |
| Aviation | 237 | 0.2% |
| Undefined | 4 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| online | 62840 | |
| ta | 62840 | |
| offline | 30379 | |
| ta/to | 30379 | |
| groups | 26115 | |
| direct | 14973 | 6.4% |
| corporate | 6486 | 2.8% |
| complementary | 913 | 0.4% |
| aviation | 237 | 0.1% |
| undefined | 4 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 157217 | |
| O | 123598 | |
| T | 123598 | |
| e | 116512 | |
| i | 108670 | |
| l | 94132 | 7.4% |
| A | 93456 | 7.3% |
| 93219 | 7.3% | |
| f | 60762 | 4.8% |
| r | 54973 | 4.3% |
| Other values (16) | 253053 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 766449 | |
| Uppercase Letter | 389143 | |
| Space Separator | 93219 | 7.3% |
| Other Punctuation | 30379 | 2.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 157217 | |
| e | 116512 | |
| i | 108670 | |
| l | 94132 | |
| f | 60762 | 7.9% |
| r | 54973 | 7.2% |
| o | 40237 | 5.2% |
| p | 33514 | 4.4% |
| s | 26115 | 3.4% |
| u | 26115 | 3.4% |
| Other values (7) | 48202 | 6.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 123598 | |
| T | 123598 | |
| A | 93456 | |
| G | 26115 | 6.7% |
| D | 14973 | 3.8% |
| C | 7399 | 1.9% |
| U | 4 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 93219 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 30379 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1155592 | |
| Common | 123598 | 9.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 157217 | |
| O | 123598 | |
| T | 123598 | |
| e | 116512 | |
| i | 108670 | |
| l | 94132 | |
| A | 93456 | |
| f | 60762 | 5.3% |
| r | 54973 | 4.8% |
| o | 40237 | 3.5% |
| Other values (14) | 182437 |
Common
| Value | Count | Frequency (%) |
| 93219 | ||
| / | 30379 | 24.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1279190 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 157217 | |
| O | 123598 | |
| T | 123598 | |
| e | 116512 | |
| i | 108670 | |
| l | 94132 | 7.4% |
| A | 93456 | 7.3% |
| 93219 | 7.3% | |
| f | 60762 | 4.8% |
| r | 54973 | 4.3% |
| Other values (16) | 253053 |
distribution_channel
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| TA/TO | |
|---|---|
| Direct | |
| Corporate | 8167 |
| GDS | 194 |
| Undefined | 10 |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 5.3512156 |
| Min length | 3 |
Characters and Unicode
| Total characters | 759589 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | TA/TO |
|---|---|
| 2nd row | TA/TO |
| 3rd row | TA/TO |
| 4th row | TA/TO |
| 5th row | Direct |
Common Values
| Value | Count | Frequency (%) |
| TA/TO | 116042 | |
| Direct | 17534 | 12.4% |
| Corporate | 8167 | 5.8% |
| GDS | 194 | 0.1% |
| Undefined | 10 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| ta/to | 116042 | |
| direct | 17534 | 12.4% |
| corporate | 8167 | 5.8% |
| gds | 194 | 0.1% |
| undefined | 10 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 232084 | |
| / | 116042 | |
| O | 116042 | |
| A | 116042 | |
| r | 33868 | 4.5% |
| e | 25721 | 3.4% |
| t | 25701 | 3.4% |
| D | 17728 | 2.3% |
| i | 17544 | 2.3% |
| c | 17534 | 2.3% |
| Other values (10) | 41283 | 5.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 490461 | |
| Lowercase Letter | 153086 | 20.2% |
| Other Punctuation | 116042 | 15.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 33868 | |
| e | 25721 | |
| t | 25701 | |
| i | 17544 | |
| c | 17534 | |
| o | 16334 | |
| a | 8167 | 5.3% |
| p | 8167 | 5.3% |
| n | 20 | < 0.1% |
| d | 20 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 232084 | |
| O | 116042 | |
| A | 116042 | |
| D | 17728 | 3.6% |
| C | 8167 | 1.7% |
| G | 194 | < 0.1% |
| S | 194 | < 0.1% |
| U | 10 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 116042 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 643547 | |
| Common | 116042 | 15.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| T | 232084 | |
| O | 116042 | |
| A | 116042 | |
| r | 33868 | 5.3% |
| e | 25721 | 4.0% |
| t | 25701 | 4.0% |
| D | 17728 | 2.8% |
| i | 17544 | 2.7% |
| c | 17534 | 2.7% |
| o | 16334 | 2.5% |
| Other values (9) | 24949 | 3.9% |
Common
| Value | Count | Frequency (%) |
| / | 116042 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 759589 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| T | 232084 | |
| / | 116042 | |
| O | 116042 | |
| A | 116042 | |
| r | 33868 | 4.5% |
| e | 25721 | 3.4% |
| t | 25701 | 3.4% |
| D | 17728 | 2.3% |
| i | 17544 | 2.3% |
| c | 17534 | 2.3% |
| Other values (10) | 41283 | 5.4% |
is_repeated_guest
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 | 4452 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 141947 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 137495 | |
| 1 | 4452 | 3.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 137495 | |
| 1 | 4452 | 3.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 137495 | |
| 1 | 4452 | 3.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 141947 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 137495 | |
| 1 | 4452 | 3.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 141947 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 137495 | |
| 1 | 4452 | 3.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 141947 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 137495 | |
| 1 | 4452 | 3.1% |
previous_cancellations
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.12541301 |
| Minimum | 0 |
|---|---|
| Maximum | 26 |
| Zeros | 131027 |
| Zeros (%) | 92.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 26 |
| Range | 26 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.0596306 |
|---|---|
| Coefficient of variation (CV) | 8.4491288 |
| Kurtosis | 448.44148 |
| Mean | 0.12541301 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 20.228688 |
| Sum | 17802 |
| Variance | 1.1228171 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 131027 | |
| 1 | 10313 | 7.3% |
| 2 | 147 | 0.1% |
| 24 | 96 | 0.1% |
| 3 | 73 | 0.1% |
| 26 | 52 | < 0.1% |
| 25 | 50 | < 0.1% |
| 19 | 38 | < 0.1% |
| 11 | 37 | < 0.1% |
| 4 | 31 | < 0.1% |
| Other values (5) | 83 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 131027 | |
| 1 | 10313 | 7.3% |
| 2 | 147 | 0.1% |
| 3 | 73 | 0.1% |
| 4 | 31 | < 0.1% |
| 5 | 19 | < 0.1% |
| 6 | 22 | < 0.1% |
| 11 | 37 | < 0.1% |
| 13 | 12 | < 0.1% |
| 14 | 28 | < 0.1% |
| Value | Count | Frequency (%) |
| 26 | 52 | |
| 25 | 50 | |
| 24 | 96 | |
| 21 | 2 | < 0.1% |
| 19 | 38 | < 0.1% |
| 14 | 28 | < 0.1% |
| 13 | 12 | < 0.1% |
| 11 | 37 | < 0.1% |
| 6 | 22 | < 0.1% |
| 5 | 19 | < 0.1% |
previous_bookings_not_canceled
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 73 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1203266 |
| Minimum | 0 |
|---|---|
| Maximum | 72 |
| Zeros | 138008 |
| Zeros (%) | 97.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 72 |
| Range | 72 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.381798 |
|---|---|
| Coefficient of variation (CV) | 11.483728 |
| Kurtosis | 892.0841 |
| Mean | 0.1203266 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 25.290755 |
| Sum | 17080 |
| Variance | 1.9093657 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 138008 | |
| 1 | 1721 | 1.2% |
| 2 | 643 | 0.5% |
| 3 | 361 | 0.3% |
| 4 | 240 | 0.2% |
| 5 | 192 | 0.1% |
| 6 | 122 | 0.1% |
| 7 | 94 | 0.1% |
| 8 | 74 | 0.1% |
| 9 | 63 | < 0.1% |
| Other values (63) | 429 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 138008 | |
| 1 | 1721 | 1.2% |
| 2 | 643 | 0.5% |
| 3 | 361 | 0.3% |
| 4 | 240 | 0.2% |
| 5 | 192 | 0.1% |
| 6 | 122 | 0.1% |
| 7 | 94 | 0.1% |
| 8 | 74 | 0.1% |
| 9 | 63 | < 0.1% |
| Value | Count | Frequency (%) |
| 72 | 1 | |
| 71 | 1 | |
| 70 | 1 | |
| 69 | 1 | |
| 68 | 1 | |
| 67 | 1 | |
| 66 | 1 | |
| 65 | 1 | |
| 64 | 1 | |
| 63 | 1 |
reserved_room_type
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| A | |
|---|---|
| D | |
| E | 7530 |
| F | 3279 |
| G | 2371 |
| Other values (5) | 3190 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 141947 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | D |
| 3rd row | E |
| 4th row | E |
| 5th row | E |
Common Values
| Value | Count | Frequency (%) |
| A | 104124 | |
| D | 21453 | 15.1% |
| E | 7530 | 5.3% |
| F | 3279 | 2.3% |
| G | 2371 | 1.7% |
| B | 1367 | 1.0% |
| C | 1107 | 0.8% |
| H | 691 | 0.5% |
| P | 13 | < 0.1% |
| L | 12 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| a | 104124 | |
| d | 21453 | 15.1% |
| e | 7530 | 5.3% |
| f | 3279 | 2.3% |
| g | 2371 | 1.7% |
| b | 1367 | 1.0% |
| c | 1107 | 0.8% |
| h | 691 | 0.5% |
| p | 13 | < 0.1% |
| l | 12 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 104124 | |
| D | 21453 | 15.1% |
| E | 7530 | 5.3% |
| F | 3279 | 2.3% |
| G | 2371 | 1.7% |
| B | 1367 | 1.0% |
| C | 1107 | 0.8% |
| H | 691 | 0.5% |
| P | 13 | < 0.1% |
| L | 12 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 141947 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 104124 | |
| D | 21453 | 15.1% |
| E | 7530 | 5.3% |
| F | 3279 | 2.3% |
| G | 2371 | 1.7% |
| B | 1367 | 1.0% |
| C | 1107 | 0.8% |
| H | 691 | 0.5% |
| P | 13 | < 0.1% |
| L | 12 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 141947 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 104124 | |
| D | 21453 | 15.1% |
| E | 7530 | 5.3% |
| F | 3279 | 2.3% |
| G | 2371 | 1.7% |
| B | 1367 | 1.0% |
| C | 1107 | 0.8% |
| H | 691 | 0.5% |
| P | 13 | < 0.1% |
| L | 12 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 141947 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 104124 | |
| D | 21453 | 15.1% |
| E | 7530 | 5.3% |
| F | 3279 | 2.3% |
| G | 2371 | 1.7% |
| B | 1367 | 1.0% |
| C | 1107 | 0.8% |
| H | 691 | 0.5% |
| P | 13 | < 0.1% |
| L | 12 | < 0.1% |
assigned_room_type
Categorical
HIGH CORRELATION  IMBALANCE 
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| A | |
|---|---|
| D | |
| E | |
| F | 4397 |
| G | 2955 |
| Other values (7) | 7124 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 141947 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | D |
| 3rd row | E |
| 4th row | E |
| 5th row | E |
Common Values
| Value | Count | Frequency (%) |
| A | 88864 | |
| D | 29427 | 20.7% |
| E | 9180 | 6.5% |
| F | 4397 | 3.1% |
| G | 2955 | 2.1% |
| C | 2861 | 2.0% |
| B | 2684 | 1.9% |
| H | 847 | 0.6% |
| I | 409 | 0.3% |
| K | 308 | 0.2% |
| Other values (2) | 15 | < 0.1% |
Length
| Value | Count | Frequency (%) |
| a | 88864 | |
| d | 29427 | 20.7% |
| e | 9180 | 6.5% |
| f | 4397 | 3.1% |
| g | 2955 | 2.1% |
| c | 2861 | 2.0% |
| b | 2684 | 1.9% |
| h | 847 | 0.6% |
| i | 409 | 0.3% |
| k | 308 | 0.2% |
| Other values (2) | 15 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 88864 | |
| D | 29427 | 20.7% |
| E | 9180 | 6.5% |
| F | 4397 | 3.1% |
| G | 2955 | 2.1% |
| C | 2861 | 2.0% |
| B | 2684 | 1.9% |
| H | 847 | 0.6% |
| I | 409 | 0.3% |
| K | 308 | 0.2% |
| Other values (2) | 15 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 141947 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 88864 | |
| D | 29427 | 20.7% |
| E | 9180 | 6.5% |
| F | 4397 | 3.1% |
| G | 2955 | 2.1% |
| C | 2861 | 2.0% |
| B | 2684 | 1.9% |
| H | 847 | 0.6% |
| I | 409 | 0.3% |
| K | 308 | 0.2% |
| Other values (2) | 15 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 141947 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 88864 | |
| D | 29427 | 20.7% |
| E | 9180 | 6.5% |
| F | 4397 | 3.1% |
| G | 2955 | 2.1% |
| C | 2861 | 2.0% |
| B | 2684 | 1.9% |
| H | 847 | 0.6% |
| I | 409 | 0.3% |
| K | 308 | 0.2% |
| Other values (2) | 15 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 141947 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 88864 | |
| D | 29427 | 20.7% |
| E | 9180 | 6.5% |
| F | 4397 | 3.1% |
| G | 2955 | 2.1% |
| C | 2861 | 2.0% |
| B | 2684 | 1.9% |
| H | 847 | 0.6% |
| I | 409 | 0.3% |
| K | 308 | 0.2% |
| Other values (2) | 15 | < 0.1% |
booking_changes
Real number (ℝ)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.21393901 |
| Minimum | 0 |
|---|---|
| Maximum | 21 |
| Zeros | 120861 |
| Zeros (%) | 85.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.63647896 |
|---|---|
| Coefficient of variation (CV) | 2.9750487 |
| Kurtosis | 85.953003 |
| Mean | 0.21393901 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.1525617 |
| Sum | 30368 |
| Variance | 0.40510546 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 120861 | |
| 1 | 15064 | 10.6% |
| 2 | 4271 | 3.0% |
| 3 | 1044 | 0.7% |
| 4 | 415 | 0.3% |
| 5 | 136 | 0.1% |
| 6 | 64 | < 0.1% |
| 7 | 33 | < 0.1% |
| 8 | 18 | < 0.1% |
| 9 | 8 | < 0.1% |
| Other values (11) | 33 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 120861 | |
| 1 | 15064 | 10.6% |
| 2 | 4271 | 3.0% |
| 3 | 1044 | 0.7% |
| 4 | 415 | 0.3% |
| 5 | 136 | 0.1% |
| 6 | 64 | < 0.1% |
| 7 | 33 | < 0.1% |
| 8 | 18 | < 0.1% |
| 9 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 20 | 2 | < 0.1% |
| 18 | 1 | < 0.1% |
| 17 | 3 | |
| 16 | 2 | < 0.1% |
| 15 | 3 | |
| 14 | 5 | |
| 13 | 5 | |
| 12 | 2 | < 0.1% |
| 11 | 3 |
deposit_type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| No Deposit | |
|---|---|
| Non Refund | |
| Refundable | 166 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 1419470 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No Deposit |
|---|---|
| 2nd row | No Deposit |
| 3rd row | No Deposit |
| 4th row | No Deposit |
| 5th row | No Deposit |
Common Values
| Value | Count | Frequency (%) |
| No Deposit | 123396 | |
| Non Refund | 18385 | 13.0% |
| Refundable | 166 | 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| no | 123396 | |
| deposit | 123396 | |
| non | 18385 | 6.5% |
| refund | 18385 | 6.5% |
| refundable | 166 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 265177 | |
| e | 142113 | |
| N | 141781 | |
| 141781 | ||
| s | 123396 | |
| i | 123396 | |
| t | 123396 | |
| p | 123396 | |
| D | 123396 | |
| n | 36936 | 2.6% |
| Other values (7) | 74702 | 5.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 993961 | |
| Uppercase Letter | 283728 | 20.0% |
| Space Separator | 141781 | 10.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 265177 | |
| e | 142113 | |
| s | 123396 | |
| i | 123396 | |
| t | 123396 | |
| p | 123396 | |
| n | 36936 | 3.7% |
| f | 18551 | 1.9% |
| u | 18551 | 1.9% |
| d | 18551 | 1.9% |
| Other values (3) | 498 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 141781 | |
| D | 123396 | |
| R | 18551 | 6.5% |
Space Separator
| Value | Count | Frequency (%) |
| 141781 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1277689 | |
| Common | 141781 | 10.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 265177 | |
| e | 142113 | |
| N | 141781 | |
| s | 123396 | |
| i | 123396 | |
| t | 123396 | |
| p | 123396 | |
| D | 123396 | |
| n | 36936 | 2.9% |
| R | 18551 | 1.5% |
| Other values (6) | 56151 | 4.4% |
Common
| Value | Count | Frequency (%) |
| 141781 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1419470 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 265177 | |
| e | 142113 | |
| N | 141781 | |
| 141781 | ||
| s | 123396 | |
| i | 123396 | |
| t | 123396 | |
| p | 123396 | |
| D | 123396 | |
| n | 36936 | 2.6% |
| Other values (7) | 74702 | 5.3% |
agent
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 333 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 19555 |
| Missing (%) | 13.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 85.685854 |
| Minimum | 1 |
|---|---|
| Maximum | 535 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 9 |
| median | 14 |
| Q3 | 229 |
| 95-th percentile | 250 |
| Maximum | 535 |
| Range | 534 |
| Interquartile range (IQR) | 220 |
Descriptive statistics
| Standard deviation | 109.6286 |
|---|---|
| Coefficient of variation (CV) | 1.2794247 |
| Kurtosis | -0.094985221 |
| Mean | 85.685854 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 1.071188 |
| Sum | 10487263 |
| Variance | 12018.429 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9 | 34292 | |
| 240 | 16686 | |
| 1 | 11395 | 8.0% |
| 6 | 4506 | 3.2% |
| 14 | 4021 | 2.8% |
| 7 | 3878 | 2.7% |
| 250 | 3357 | 2.4% |
| 241 | 2052 | 1.4% |
| 28 | 1977 | 1.4% |
| 3 | 1781 | 1.3% |
| Other values (323) | 38447 | |
| (Missing) | 19555 |
| Value | Count | Frequency (%) |
| 1 | 11395 | 8.0% |
| 2 | 208 | 0.1% |
| 3 | 1781 | 1.3% |
| 4 | 86 | 0.1% |
| 5 | 492 | 0.3% |
| 6 | 4506 | 3.2% |
| 7 | 3878 | 2.7% |
| 8 | 1765 | 1.2% |
| 9 | 34292 | |
| 10 | 320 | 0.2% |
| Value | Count | Frequency (%) |
| 535 | 3 | < 0.1% |
| 531 | 68 | |
| 527 | 35 | |
| 526 | 10 | < 0.1% |
| 510 | 2 | < 0.1% |
| 509 | 10 | < 0.1% |
| 508 | 6 | < 0.1% |
| 502 | 24 | < 0.1% |
| 497 | 1 | < 0.1% |
| 495 | 57 |
company
Real number (ℝ)
HIGH CORRELATION  MISSING 
| Distinct | 352 |
|---|---|
| Distinct (%) | 4.3% |
| Missing | 133822 |
| Missing (%) | 94.3% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 183.23606 |
| Minimum | 6 |
|---|---|
| Maximum | 543 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 40 |
| Q1 | 51 |
| median | 174 |
| Q3 | 269 |
| 95-th percentile | 418.8 |
| Maximum | 543 |
| Range | 537 |
| Interquartile range (IQR) | 218 |
Descriptive statistics
| Standard deviation | 128.92195 |
|---|---|
| Coefficient of variation (CV) | 0.70358394 |
| Kurtosis | -0.46230987 |
| Mean | 183.23606 |
| Median Absolute Deviation (MAD) | 107 |
| Skewness | 0.60858559 |
| Sum | 1488793 |
| Variance | 16620.869 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40 | 1165 | 0.8% |
| 223 | 981 | 0.7% |
| 45 | 312 | 0.2% |
| 281 | 269 | 0.2% |
| 67 | 268 | 0.2% |
| 153 | 215 | 0.2% |
| 174 | 170 | 0.1% |
| 154 | 151 | 0.1% |
| 219 | 141 | 0.1% |
| 405 | 119 | 0.1% |
| Other values (342) | 4334 | 3.1% |
| (Missing) | 133822 |
| Value | Count | Frequency (%) |
| 6 | 1 | < 0.1% |
| 8 | 2 | < 0.1% |
| 9 | 55 | |
| 10 | 1 | < 0.1% |
| 11 | 2 | < 0.1% |
| 12 | 17 | < 0.1% |
| 14 | 9 | < 0.1% |
| 16 | 7 | < 0.1% |
| 18 | 1 | < 0.1% |
| 20 | 69 |
| Value | Count | Frequency (%) |
| 543 | 2 | < 0.1% |
| 541 | 1 | < 0.1% |
| 539 | 2 | < 0.1% |
| 534 | 2 | < 0.1% |
| 531 | 1 | < 0.1% |
| 530 | 5 | < 0.1% |
| 528 | 2 | < 0.1% |
| 525 | 15 | |
| 523 | 19 | |
| 521 | 7 | < 0.1% |
days_in_waiting_list
Real number (ℝ)
| Distinct | 128 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.3055648 |
| Minimum | 0 |
|---|---|
| Maximum | 391 |
| Zeros | 137500 |
| Zeros (%) | 96.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 391 |
| Range | 391 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 16.938253 |
|---|---|
| Coefficient of variation (CV) | 7.3466829 |
| Kurtosis | 185.29882 |
| Mean | 2.3055648 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.706837 |
| Sum | 327268 |
| Variance | 286.90442 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 137500 | |
| 58 | 328 | 0.2% |
| 39 | 227 | 0.2% |
| 87 | 160 | 0.1% |
| 44 | 141 | 0.1% |
| 31 | 127 | 0.1% |
| 69 | 125 | 0.1% |
| 50 | 110 | 0.1% |
| 122 | 109 | 0.1% |
| 77 | 101 | 0.1% |
| Other values (118) | 3019 | 2.1% |
| Value | Count | Frequency (%) |
| 0 | 137500 | |
| 1 | 12 | < 0.1% |
| 2 | 5 | < 0.1% |
| 3 | 59 | < 0.1% |
| 4 | 25 | < 0.1% |
| 5 | 8 | < 0.1% |
| 6 | 26 | < 0.1% |
| 7 | 4 | < 0.1% |
| 8 | 7 | < 0.1% |
| 9 | 16 | < 0.1% |
| Value | Count | Frequency (%) |
| 391 | 45 | |
| 379 | 15 | < 0.1% |
| 330 | 15 | < 0.1% |
| 259 | 10 | < 0.1% |
| 236 | 35 | |
| 224 | 10 | < 0.1% |
| 223 | 61 | |
| 215 | 21 | < 0.1% |
| 207 | 15 | < 0.1% |
| 193 | 1 | < 0.1% |
customer_type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Transient | |
|---|---|
| Transient-Party | |
| Contract | 6747 |
| Group | 772 |
Length
| Max length | 15 |
|---|---|
| Median length | 9 |
| Mean length | 10.323656 |
| Min length | 5 |
Characters and Unicode
| Total characters | 1465412 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Transient |
|---|---|
| 2nd row | Transient |
| 3rd row | Transient |
| 4th row | Transient |
| 5th row | Transient |
Common Values
| Value | Count | Frequency (%) |
| Transient | 101474 | |
| Transient-Party | 32954 | 23.2% |
| Contract | 6747 | 4.8% |
| Group | 772 | 0.5% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| transient | 101474 | |
| transient-party | 32954 | 23.2% |
| contract | 6747 | 4.8% |
| group | 772 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 275603 | |
| t | 180876 | |
| r | 174901 | |
| a | 174129 | |
| T | 134428 | |
| s | 134428 | |
| i | 134428 | |
| e | 134428 | |
| y | 32954 | 2.2% |
| - | 32954 | 2.2% |
| Other values (7) | 56283 | 3.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1257557 | |
| Uppercase Letter | 174901 | 11.9% |
| Dash Punctuation | 32954 | 2.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 275603 | |
| t | 180876 | |
| r | 174901 | |
| a | 174129 | |
| s | 134428 | |
| i | 134428 | |
| e | 134428 | |
| y | 32954 | 2.6% |
| o | 7519 | 0.6% |
| c | 6747 | 0.5% |
| Other values (2) | 1544 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 134428 | |
| P | 32954 | 18.8% |
| C | 6747 | 3.9% |
| G | 772 | 0.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 32954 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1432458 | |
| Common | 32954 | 2.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 275603 | |
| t | 180876 | |
| r | 174901 | |
| a | 174129 | |
| T | 134428 | |
| s | 134428 | |
| i | 134428 | |
| e | 134428 | |
| y | 32954 | 2.3% |
| P | 32954 | 2.3% |
| Other values (6) | 23329 | 1.6% |
Common
| Value | Count | Frequency (%) |
| - | 32954 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1465412 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 275603 | |
| t | 180876 | |
| r | 174901 | |
| a | 174129 | |
| T | 134428 | |
| s | 134428 | |
| i | 134428 | |
| e | 134428 | |
| y | 32954 | 2.2% |
| - | 32954 | 2.2% |
| Other values (7) | 56283 | 3.8% |
adr
Real number (ℝ)
| Distinct | 8879 |
|---|---|
| Distinct (%) | 6.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 99.416916 |
| Minimum | -6.38 |
|---|---|
| Maximum | 5400 |
| Zeros | 2555 |
| Zeros (%) | 1.8% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | -6.38 |
|---|---|
| 5-th percentile | 37.4 |
| Q1 | 65.75 |
| median | 90.95 |
| Q3 | 123 |
| 95-th percentile | 190 |
| Maximum | 5400 |
| Range | 5406.38 |
| Interquartile range (IQR) | 57.25 |
Descriptive statistics
| Standard deviation | 49.675549 |
|---|---|
| Coefficient of variation (CV) | 0.49966898 |
| Kurtosis | 914.64899 |
| Mean | 99.416916 |
| Median Absolute Deviation (MAD) | 27.55 |
| Skewness | 9.4554177 |
| Sum | 14111933 |
| Variance | 2467.6602 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 62 | 6172 | 4.3% |
| 75 | 3252 | 2.3% |
| 90 | 3051 | 2.1% |
| 65 | 2997 | 2.1% |
| 0 | 2555 | 1.8% |
| 80 | 2181 | 1.5% |
| 60 | 1859 | 1.3% |
| 100 | 1856 | 1.3% |
| 95 | 1777 | 1.3% |
| 120 | 1731 | 1.2% |
| Other values (8869) | 114516 |
| Value | Count | Frequency (%) |
| -6.38 | 1 | < 0.1% |
| 0 | 2555 | |
| 0.26 | 1 | < 0.1% |
| 0.5 | 1 | < 0.1% |
| 1 | 15 | < 0.1% |
| 1.29 | 1 | < 0.1% |
| 1.48 | 1 | < 0.1% |
| 1.56 | 2 | < 0.1% |
| 1.6 | 2 | < 0.1% |
| 1.8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5400 | 1 | |
| 510 | 1 | |
| 508 | 2 | |
| 451.5 | 1 | |
| 450 | 1 | |
| 437 | 1 | |
| 426.25 | 1 | |
| 402 | 1 | |
| 397.38 | 1 | |
| 392 | 2 |
required_car_parking_spaces
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 0 | |
|---|---|
| 1 | 8730 |
| 2 | 32 |
| 3 | 3 |
| 8 | 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 141947 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 133180 | |
| 1 | 8730 | 6.2% |
| 2 | 32 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 133180 | |
| 1 | 8730 | 6.2% |
| 2 | 32 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 133180 | |
| 1 | 8730 | 6.2% |
| 2 | 32 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 141947 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 133180 | |
| 1 | 8730 | 6.2% |
| 2 | 32 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 141947 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 133180 | |
| 1 | 8730 | 6.2% |
| 2 | 32 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 141947 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 133180 | |
| 1 | 8730 | 6.2% |
| 2 | 32 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
total_of_special_requests
Real number (ℝ)
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.54967699 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 86024 |
| Zeros (%) | 60.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.1 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.7865411 |
|---|---|
| Coefficient of variation (CV) | 1.4309151 |
| Kurtosis | 1.577907 |
| Mean | 0.54967699 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.3946317 |
| Sum | 78025 |
| Variance | 0.6186469 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 86024 | |
| 1 | 37564 | |
| 2 | 15066 | 10.6% |
| 3 | 2887 | 2.0% |
| 4 | 362 | 0.3% |
| 5 | 44 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 86024 | |
| 1 | 37564 | |
| 2 | 15066 | 10.6% |
| 3 | 2887 | 2.0% |
| 4 | 362 | 0.3% |
| 5 | 44 | < 0.1% |
| Value | Count | Frequency (%) |
| 5 | 44 | < 0.1% |
| 4 | 362 | 0.3% |
| 3 | 2887 | 2.0% |
| 2 | 15066 | 10.6% |
| 1 | 37564 | |
| 0 | 86024 |
reservation_status
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| Check-Out | |
|---|---|
| Canceled | |
| No-Show | 1470 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.6180335 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1223304 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Canceled |
|---|---|
| 2nd row | Canceled |
| 3rd row | Canceled |
| 4th row | Canceled |
| 5th row | Canceled |
Common Values
| Value | Count | Frequency (%) |
| Check-Out | 89198 | |
| Canceled | 51279 | |
| No-Show | 1470 | 1.0% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| check-out | 89198 | |
| canceled | 51279 | |
| no-show | 1470 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 191756 | |
| C | 140477 | |
| c | 140477 | |
| h | 90668 | |
| - | 90668 | |
| u | 89198 | |
| t | 89198 | |
| O | 89198 | |
| k | 89198 | |
| a | 51279 | 4.2% |
| Other values (7) | 161187 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 900021 | |
| Uppercase Letter | 232615 | 19.0% |
| Dash Punctuation | 90668 | 7.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 191756 | |
| c | 140477 | |
| h | 90668 | |
| u | 89198 | |
| t | 89198 | |
| k | 89198 | |
| a | 51279 | 5.7% |
| n | 51279 | 5.7% |
| l | 51279 | 5.7% |
| d | 51279 | 5.7% |
| Other values (2) | 4410 | 0.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 140477 | |
| O | 89198 | |
| N | 1470 | 0.6% |
| S | 1470 | 0.6% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 90668 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1132636 | |
| Common | 90668 | 7.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 191756 | |
| C | 140477 | |
| c | 140477 | |
| h | 90668 | |
| u | 89198 | |
| t | 89198 | |
| O | 89198 | |
| k | 89198 | |
| a | 51279 | 4.5% |
| n | 51279 | 4.5% |
| Other values (6) | 109908 |
Common
| Value | Count | Frequency (%) |
| - | 90668 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1223304 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 191756 | |
| C | 140477 | |
| c | 140477 | |
| h | 90668 | |
| - | 90668 | |
| u | 89198 | |
| t | 89198 | |
| O | 89198 | |
| k | 89198 | |
| a | 51279 | 4.2% |
| Other values (7) | 161187 |
reservation_status_date
Categorical
| Distinct | 925 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.1 MiB |
| 2018-10-21 | 1461 |
|---|---|
| 2019-01-01 | 951 |
| 2019-07-06 | 931 |
| 2019-11-25 | 842 |
| 2018-07-06 | 805 |
| Other values (920) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 1419470 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 27 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2018-05-06 |
|---|---|
| 2nd row | 2018-04-22 |
| 3rd row | 2018-06-23 |
| 4th row | 2018-05-11 |
| 5th row | 2018-05-29 |
Common Values
| Value | Count | Frequency (%) |
| 2018-10-21 | 1461 | 1.0% |
| 2019-01-01 | 951 | 0.7% |
| 2019-07-06 | 931 | 0.7% |
| 2019-11-25 | 842 | 0.6% |
| 2018-07-06 | 805 | 0.6% |
| 2018-01-01 | 763 | 0.5% |
| 2019-01-18 | 633 | 0.4% |
| 2019-07-02 | 597 | 0.4% |
| 2019-12-07 | 534 | 0.4% |
| 2018-07-02 | 469 | 0.3% |
| Other values (915) | 133961 |
Length
| Value | Count | Frequency (%) |
| 2018-10-21 | 1461 | 1.0% |
| 2019-01-01 | 951 | 0.7% |
| 2019-07-06 | 931 | 0.7% |
| 2019-11-25 | 842 | 0.6% |
| 2018-07-06 | 805 | 0.6% |
| 2018-01-01 | 763 | 0.5% |
| 2019-01-18 | 633 | 0.4% |
| 2019-07-02 | 597 | 0.4% |
| 2019-12-07 | 534 | 0.4% |
| 2018-07-02 | 469 | 0.3% |
| Other values (915) | 133961 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 356903 | |
| - | 283894 | |
| 2 | 257810 | |
| 1 | 228293 | |
| 9 | 107594 | 7.6% |
| 8 | 53318 | 3.8% |
| 3 | 30540 | 2.2% |
| 7 | 29293 | 2.1% |
| 6 | 24754 | 1.7% |
| 5 | 23853 | 1.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1135576 | |
| Dash Punctuation | 283894 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 356903 | |
| 2 | 257810 | |
| 1 | 228293 | |
| 9 | 107594 | 9.5% |
| 8 | 53318 | 4.7% |
| 3 | 30540 | 2.7% |
| 7 | 29293 | 2.6% |
| 6 | 24754 | 2.2% |
| 5 | 23853 | 2.1% |
| 4 | 23218 | 2.0% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 283894 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1419470 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 356903 | |
| - | 283894 | |
| 2 | 257810 | |
| 1 | 228293 | |
| 9 | 107594 | 7.6% |
| 8 | 53318 | 3.8% |
| 3 | 30540 | 2.2% |
| 7 | 29293 | 2.1% |
| 6 | 24754 | 1.7% |
| 5 | 23853 | 1.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1419470 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 356903 | |
| - | 283894 | |
| 2 | 257810 | |
| 1 | 228293 | |
| 9 | 107594 | 7.6% |
| 8 | 53318 | 3.8% |
| 3 | 30540 | 2.2% |
| 7 | 29293 | 2.1% |
| 6 | 24754 | 1.7% |
| 5 | 23853 | 1.7% |
| lead_time | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | previous_cancellations | previous_bookings_not_canceled | booking_changes | agent | company | days_in_waiting_list | adr | total_of_special_requests | hotel | is_canceled | arrival_date_year | arrival_date_month | children | babies | meal | market_segment | distribution_channel | is_repeated_guest | reserved_room_type | assigned_room_type | deposit_type | customer_type | required_car_parking_spaces | reservation_status | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| lead_time | 1.000 | 0.043 | 0.001 | 0.156 | 0.277 | 0.194 | 0.235 | -0.180 | -0.020 | -0.152 | 0.308 | 0.137 | -0.005 | -0.091 | 0.105 | 0.308 | 0.099 | 0.129 | 0.030 | 0.010 | 0.088 | 0.173 | 0.116 | 0.123 | 0.050 | 0.066 | 0.286 | 0.131 | 0.058 | 0.227 |
| arrival_date_week_number | 0.043 | 1.000 | 0.065 | 0.006 | 0.001 | -0.014 | 0.116 | -0.039 | 0.005 | -0.058 | -0.067 | 0.017 | -0.031 | -0.013 | 0.080 | 0.070 | 0.402 | 0.800 | 0.059 | 0.016 | 0.093 | 0.088 | 0.069 | 0.069 | 0.044 | 0.031 | 0.102 | 0.125 | 0.019 | 0.064 |
| arrival_date_day_of_month | 0.001 | 0.065 | 1.000 | -0.016 | -0.014 | 0.006 | -0.020 | 0.000 | 0.012 | 0.003 | 0.051 | 0.042 | 0.034 | 0.007 | 0.033 | 0.022 | 0.037 | 0.065 | 0.013 | 0.006 | 0.051 | 0.040 | 0.032 | 0.021 | 0.012 | 0.011 | 0.063 | 0.040 | 0.010 | 0.025 |
| stays_in_weekend_nights | 0.156 | 0.006 | -0.016 | 1.000 | 0.238 | 0.130 | -0.055 | -0.080 | 0.038 | 0.133 | 0.079 | -0.076 | 0.053 | 0.081 | 0.201 | 0.022 | 0.023 | 0.046 | 0.031 | 0.011 | 0.058 | 0.058 | 0.055 | 0.082 | 0.054 | 0.051 | 0.074 | 0.075 | 0.012 | 0.022 |
| stays_in_week_nights | 0.277 | 0.001 | -0.014 | 0.238 | 1.000 | 0.147 | -0.070 | -0.115 | 0.067 | 0.193 | 0.259 | 0.019 | 0.106 | 0.091 | 0.198 | 0.031 | 0.011 | 0.036 | 0.016 | 0.000 | 0.041 | 0.035 | 0.007 | 0.019 | 0.046 | 0.047 | 0.049 | 0.071 | 0.015 | 0.031 |
| adults | 0.194 | -0.014 | 0.006 | 0.130 | 0.147 | 1.000 | -0.020 | -0.202 | -0.090 | -0.046 | 0.218 | -0.031 | 0.265 | 0.161 | 0.018 | 0.017 | 0.008 | 0.013 | 0.000 | 0.000 | 0.000 | 0.013 | 0.012 | 0.000 | 0.009 | 0.007 | 0.000 | 0.110 | 0.000 | 0.012 |
| previous_cancellations | 0.235 | 0.116 | -0.020 | -0.055 | -0.070 | -0.020 | 1.000 | 0.068 | -0.090 | -0.227 | -0.155 | 0.061 | -0.170 | -0.157 | 0.062 | 0.056 | 0.034 | 0.036 | 0.003 | 0.000 | 0.101 | 0.051 | 0.050 | 0.169 | 0.009 | 0.011 | 0.064 | 0.011 | 0.000 | 0.040 |
| previous_bookings_not_canceled | -0.180 | -0.039 | 0.000 | -0.080 | -0.115 | -0.202 | 0.068 | 1.000 | 0.031 | 0.058 | -0.270 | -0.019 | -0.131 | 0.024 | 0.016 | 0.039 | 0.024 | 0.018 | 0.000 | 0.000 | 0.013 | 0.089 | 0.099 | 0.300 | 0.001 | 0.003 | 0.013 | 0.015 | 0.017 | 0.028 |
| booking_changes | -0.020 | 0.005 | 0.012 | 0.038 | 0.067 | -0.090 | -0.090 | 0.031 | 1.000 | 0.095 | 0.194 | -0.012 | 0.009 | 0.045 | 0.040 | 0.049 | 0.015 | 0.011 | 0.018 | 0.014 | 0.011 | 0.021 | 0.028 | 0.000 | 0.016 | 0.057 | 0.029 | 0.029 | 0.018 | 0.036 |
| agent | -0.152 | -0.058 | 0.003 | 0.133 | 0.193 | -0.046 | -0.227 | 0.058 | 0.095 | 1.000 | 0.286 | -0.004 | -0.009 | 0.069 | 0.823 | 0.095 | 0.093 | 0.086 | 0.059 | 0.027 | 0.182 | 0.226 | 0.204 | 0.083 | 0.145 | 0.135 | 0.125 | 0.136 | 0.133 | 0.070 |
| company | 0.308 | -0.067 | 0.051 | 0.079 | 0.259 | 0.218 | -0.155 | -0.270 | 0.194 | 0.286 | 1.000 | -0.006 | 0.011 | -0.109 | 0.537 | 0.110 | 0.272 | 0.237 | 0.043 | 0.056 | 0.206 | 0.387 | 0.202 | 0.337 | 0.096 | 0.086 | 0.179 | 0.248 | 0.033 | 0.086 |
| days_in_waiting_list | 0.137 | 0.017 | 0.042 | -0.076 | 0.019 | -0.031 | 0.061 | -0.019 | -0.012 | -0.004 | -0.006 | 1.000 | -0.028 | -0.121 | 0.091 | 0.049 | 0.065 | 0.065 | 0.018 | 0.000 | 0.089 | 0.075 | 0.028 | 0.025 | 0.027 | 0.027 | 0.105 | 0.081 | 0.031 | 0.038 |
| adr | -0.005 | -0.031 | 0.034 | 0.053 | 0.106 | 0.265 | -0.170 | -0.131 | 0.009 | -0.009 | 0.011 | -0.028 | 1.000 | 0.205 | 0.000 | 0.000 | 0.000 | 0.004 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.006 | 0.000 | 0.000 | 0.000 |
| total_of_special_requests | -0.091 | -0.013 | 0.007 | 0.081 | 0.091 | 0.161 | -0.157 | 0.024 | 0.045 | 0.069 | -0.109 | -0.121 | 0.205 | 1.000 | 0.066 | 0.258 | 0.087 | 0.053 | 0.065 | 0.064 | 0.066 | 0.221 | 0.069 | 0.037 | 0.082 | 0.072 | 0.220 | 0.118 | 0.047 | 0.184 |
| hotel | 0.105 | 0.080 | 0.033 | 0.201 | 0.198 | 0.018 | 0.062 | 0.016 | 0.040 | 0.823 | 0.537 | 0.091 | 0.000 | 0.066 | 1.000 | 0.137 | 0.036 | 0.085 | 0.051 | 0.049 | 0.305 | 0.155 | 0.192 | 0.032 | 0.326 | 0.393 | 0.178 | 0.067 | 0.223 | 0.139 |
| is_canceled | 0.308 | 0.070 | 0.022 | 0.022 | 0.031 | 0.017 | 0.056 | 0.039 | 0.049 | 0.095 | 0.110 | 0.049 | 0.000 | 0.258 | 0.137 | 1.000 | 0.019 | 0.073 | 0.029 | 0.035 | 0.057 | 0.280 | 0.174 | 0.063 | 0.087 | 0.227 | 0.497 | 0.112 | 0.198 | 0.999 |
| arrival_date_year | 0.099 | 0.402 | 0.037 | 0.023 | 0.011 | 0.008 | 0.034 | 0.024 | 0.015 | 0.093 | 0.272 | 0.065 | 0.000 | 0.087 | 0.036 | 0.019 | 1.000 | 0.403 | 0.042 | 0.008 | 0.106 | 0.142 | 0.025 | 0.010 | 0.077 | 0.047 | 0.046 | 0.167 | 0.015 | 0.019 |
| arrival_date_month | 0.129 | 0.800 | 0.065 | 0.046 | 0.036 | 0.013 | 0.036 | 0.018 | 0.011 | 0.086 | 0.237 | 0.065 | 0.004 | 0.053 | 0.085 | 0.073 | 0.403 | 1.000 | 0.066 | 0.019 | 0.101 | 0.094 | 0.075 | 0.069 | 0.048 | 0.029 | 0.104 | 0.124 | 0.020 | 0.066 |
| children | 0.030 | 0.059 | 0.013 | 0.031 | 0.016 | 0.000 | 0.003 | 0.000 | 0.018 | 0.059 | 0.043 | 0.018 | 0.000 | 0.065 | 0.051 | 0.029 | 0.042 | 0.066 | 1.000 | 0.025 | 0.032 | 0.102 | 0.045 | 0.032 | 0.352 | 0.297 | 0.073 | 0.066 | 0.032 | 0.038 |
| babies | 0.010 | 0.016 | 0.006 | 0.011 | 0.000 | 0.000 | 0.000 | 0.000 | 0.014 | 0.027 | 0.056 | 0.000 | 0.000 | 0.064 | 0.049 | 0.035 | 0.008 | 0.019 | 0.025 | 1.000 | 0.014 | 0.036 | 0.029 | 0.009 | 0.042 | 0.046 | 0.024 | 0.017 | 0.021 | 0.024 |
| meal | 0.088 | 0.093 | 0.051 | 0.058 | 0.041 | 0.000 | 0.101 | 0.013 | 0.011 | 0.182 | 0.206 | 0.089 | 0.000 | 0.066 | 0.305 | 0.057 | 0.106 | 0.101 | 0.032 | 0.014 | 1.000 | 0.198 | 0.074 | 0.061 | 0.093 | 0.106 | 0.094 | 0.141 | 0.024 | 0.047 |
| market_segment | 0.173 | 0.088 | 0.040 | 0.058 | 0.035 | 0.013 | 0.051 | 0.089 | 0.021 | 0.226 | 0.387 | 0.075 | 0.000 | 0.221 | 0.155 | 0.280 | 0.142 | 0.094 | 0.102 | 0.036 | 0.198 | 1.000 | 0.693 | 0.316 | 0.142 | 0.125 | 0.364 | 0.285 | 0.093 | 0.206 |
| distribution_channel | 0.116 | 0.069 | 0.032 | 0.055 | 0.007 | 0.012 | 0.050 | 0.099 | 0.028 | 0.204 | 0.202 | 0.028 | 0.000 | 0.069 | 0.192 | 0.174 | 0.025 | 0.075 | 0.045 | 0.029 | 0.074 | 0.693 | 1.000 | 0.268 | 0.106 | 0.099 | 0.090 | 0.089 | 0.074 | 0.129 |
| is_repeated_guest | 0.123 | 0.069 | 0.021 | 0.082 | 0.019 | 0.000 | 0.169 | 0.300 | 0.000 | 0.083 | 0.337 | 0.025 | 0.000 | 0.037 | 0.032 | 0.063 | 0.010 | 0.069 | 0.032 | 0.009 | 0.061 | 0.316 | 0.268 | 1.000 | 0.037 | 0.069 | 0.055 | 0.087 | 0.064 | 0.064 |
| reserved_room_type | 0.050 | 0.044 | 0.012 | 0.054 | 0.046 | 0.009 | 0.009 | 0.001 | 0.016 | 0.145 | 0.096 | 0.027 | 0.000 | 0.082 | 0.326 | 0.087 | 0.077 | 0.048 | 0.352 | 0.042 | 0.093 | 0.142 | 0.106 | 0.037 | 1.000 | 0.766 | 0.153 | 0.122 | 0.082 | 0.062 |
| assigned_room_type | 0.066 | 0.031 | 0.011 | 0.051 | 0.047 | 0.007 | 0.011 | 0.003 | 0.057 | 0.135 | 0.086 | 0.027 | 0.000 | 0.072 | 0.393 | 0.227 | 0.047 | 0.029 | 0.297 | 0.046 | 0.106 | 0.125 | 0.099 | 0.069 | 0.766 | 1.000 | 0.198 | 0.097 | 0.096 | 0.162 |
| deposit_type | 0.286 | 0.102 | 0.063 | 0.074 | 0.049 | 0.000 | 0.064 | 0.013 | 0.029 | 0.125 | 0.179 | 0.105 | 0.006 | 0.220 | 0.178 | 0.497 | 0.046 | 0.104 | 0.073 | 0.024 | 0.094 | 0.364 | 0.090 | 0.055 | 0.153 | 0.198 | 1.000 | 0.086 | 0.072 | 0.357 |
| customer_type | 0.131 | 0.125 | 0.040 | 0.075 | 0.071 | 0.110 | 0.011 | 0.015 | 0.029 | 0.136 | 0.248 | 0.081 | 0.000 | 0.118 | 0.067 | 0.112 | 0.167 | 0.124 | 0.066 | 0.017 | 0.141 | 0.285 | 0.089 | 0.087 | 0.122 | 0.097 | 0.086 | 1.000 | 0.049 | 0.079 |
| required_car_parking_spaces | 0.058 | 0.019 | 0.010 | 0.012 | 0.015 | 0.000 | 0.000 | 0.017 | 0.018 | 0.133 | 0.033 | 0.031 | 0.000 | 0.047 | 0.223 | 0.198 | 0.015 | 0.020 | 0.032 | 0.021 | 0.024 | 0.093 | 0.074 | 0.064 | 0.082 | 0.096 | 0.072 | 0.049 | 1.000 | 0.139 |
| reservation_status | 0.227 | 0.064 | 0.025 | 0.022 | 0.031 | 0.012 | 0.040 | 0.028 | 0.036 | 0.070 | 0.086 | 0.038 | 0.000 | 0.184 | 0.139 | 0.999 | 0.019 | 0.066 | 0.038 | 0.024 | 0.047 | 0.206 | 0.129 | 0.064 | 0.062 | 0.162 | 0.357 | 0.079 | 0.139 | 1.000 |
| hotel | is_canceled | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | agent | company | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | reservation_status | reservation_status_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Resort Hotel | 1 | 85 | 2018 | July | 27 | 1 | 0 | 3 | 2 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 240.0 | NaN | 0 | Transient | 82.00 | 0 | 1 | Canceled | 2018-05-06 |
| 1 | Resort Hotel | 1 | 75 | 2018 | July | 27 | 1 | 0 | 3 | 2 | 0.0 | 0 | HB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 15.0 | NaN | 0 | Transient | 105.50 | 0 | 0 | Canceled | 2018-04-22 |
| 2 | Resort Hotel | 1 | 23 | 2018 | July | 27 | 1 | 0 | 4 | 2 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | E | E | 0 | No Deposit | 240.0 | NaN | 0 | Transient | 123.00 | 0 | 0 | Canceled | 2018-06-23 |
| 3 | Resort Hotel | 1 | 60 | 2018 | July | 27 | 1 | 2 | 5 | 2 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | E | E | 0 | No Deposit | 240.0 | NaN | 0 | Transient | 107.00 | 0 | 2 | Canceled | 2018-05-11 |
| 4 | Resort Hotel | 1 | 96 | 2018 | July | 27 | 1 | 2 | 8 | 2 | 0.0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | E | E | 0 | No Deposit | NaN | NaN | 0 | Transient | 108.30 | 0 | 2 | Canceled | 2018-05-29 |
| 5 | Resort Hotel | 1 | 45 | 2018 | July | 27 | 2 | 1 | 3 | 3 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 241.0 | NaN | 0 | Transient | 108.80 | 0 | 1 | Canceled | 2018-05-19 |
| 6 | Resort Hotel | 1 | 40 | 2018 | July | 27 | 2 | 1 | 3 | 3 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 241.0 | NaN | 0 | Transient | 108.80 | 0 | 1 | Canceled | 2018-06-19 |
| 7 | Resort Hotel | 1 | 43 | 2018 | July | 27 | 2 | 1 | 3 | 3 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 241.0 | NaN | 0 | Transient | 108.80 | 0 | 0 | Canceled | 2018-05-23 |
| 8 | Resort Hotel | 1 | 45 | 2018 | July | 27 | 2 | 2 | 3 | 2 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | G | G | 0 | No Deposit | 241.0 | NaN | 0 | Transient | 117.81 | 0 | 0 | Canceled | 2018-05-18 |
| 9 | Resort Hotel | 1 | 47 | 2018 | July | 27 | 2 | 2 | 5 | 2 | 2.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | G | G | 0 | No Deposit | 240.0 | NaN | 0 | Transient | 153.00 | 0 | 0 | Canceled | 2018-06-02 |
| hotel | is_canceled | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | agent | company | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | reservation_status | reservation_status_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 141937 | City Hotel | 1 | 219 | 2020 | August | 35 | 28 | 1 | 3 | 2 | 1.0 | 0 | BB | ROU | Online TA | TA/TO | 0 | 0 | 0 | A | D | 1 | No Deposit | 9.0 | NaN | 0 | Transient | 135.00 | 0 | 2 | No-Show | 2020-08-28 |
| 141938 | City Hotel | 1 | 320 | 2020 | August | 35 | 28 | 2 | 5 | 2 | 0.0 | 0 | BB | DEU | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 9.0 | NaN | 0 | Transient | 112.76 | 0 | 3 | No-Show | 2020-08-29 |
| 141939 | City Hotel | 1 | 1 | 2020 | March | 10 | 7 | 0 | 2 | 2 | 0.0 | 0 | SC | PRT | Direct | Direct | 1 | 0 | 1 | A | A | 0 | No Deposit | NaN | NaN | 0 | Transient | 98.00 | 0 | 0 | No-Show | 2020-03-07 |
| 141940 | City Hotel | 1 | 4 | 2020 | August | 35 | 28 | 1 | 0 | 1 | 0.0 | 0 | BB | PRT | Complementary | Corporate | 1 | 0 | 3 | A | A | 0 | No Deposit | NaN | 72.0 | 0 | Transient | 0.00 | 0 | 2 | No-Show | 2020-08-28 |
| 141941 | City Hotel | 1 | 2 | 2020 | June | 24 | 11 | 2 | 1 | 1 | 0.0 | 0 | BB | PRT | Aviation | Corporate | 1 | 0 | 2 | A | A | 0 | No Deposit | NaN | 153.0 | 0 | Transient | 95.00 | 0 | 0 | No-Show | 2020-06-11 |
| 141942 | City Hotel | 1 | 1 | 2020 | February | 5 | 1 | 0 | 0 | 1 | 0.0 | 0 | BB | AUT | Aviation | Corporate | 1 | 0 | 1 | A | A | 0 | No Deposit | NaN | 153.0 | 0 | Transient | 0.00 | 0 | 1 | No-Show | 2020-02-01 |
| 141943 | City Hotel | 1 | 31 | 2020 | July | 29 | 16 | 2 | 0 | 1 | 0.0 | 0 | BB | USA | Direct | Direct | 1 | 0 | 2 | A | A | 1 | No Deposit | NaN | NaN | 0 | Transient | 135.00 | 0 | 2 | No-Show | 2020-07-16 |
| 141944 | City Hotel | 1 | 25 | 2020 | May | 18 | 6 | 2 | 1 | 1 | 0.0 | 0 | BB | FRA | Corporate | Corporate | 1 | 0 | 1 | E | F | 0 | No Deposit | NaN | 450.0 | 0 | Transient | 125.00 | 0 | 0 | No-Show | 2020-05-06 |
| 141945 | City Hotel | 1 | 6 | 2020 | July | 29 | 17 | 1 | 0 | 1 | 0.0 | 0 | BB | PRT | Corporate | Corporate | 1 | 1 | 1 | A | D | 0 | No Deposit | NaN | 238.0 | 0 | Transient | 65.00 | 0 | 0 | No-Show | 2020-07-17 |
| 141946 | City Hotel | 1 | 0 | 2020 | August | 31 | 2 | 0 | 2 | 1 | 0.0 | 0 | BB | PRT | Corporate | Corporate | 1 | 0 | 0 | A | C | 0 | No Deposit | NaN | 40.0 | 0 | Transient | 65.00 | 0 | 1 | No-Show | 2020-08-02 |
Most frequently occurring
| hotel | is_canceled | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | agent | company | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | reservation_status | reservation_status_date | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6589 | City Hotel | 1 | 277 | 2019 | November | 46 | 7 | 1 | 2 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | NaN | NaN | 0 | Transient | 100.0 | 0 | 0 | Canceled | 2019-04-04 | 180 |
| 5192 | City Hotel | 1 | 68 | 2019 | February | 8 | 17 | 0 | 2 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 1 | 0 | A | A | 0 | Non Refund | 37.0 | NaN | 0 | Transient | 75.0 | 0 | 0 | Canceled | 2019-01-06 | 150 |
| 6208 | City Hotel | 1 | 188 | 2019 | June | 25 | 15 | 0 | 2 | 1 | 0.0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 119.0 | NaN | 39 | Transient | 130.0 | 0 | 0 | Canceled | 2019-01-18 | 109 |
| 5995 | City Hotel | 1 | 158 | 2019 | May | 22 | 24 | 0 | 2 | 1 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 37.0 | NaN | 31 | Transient | 130.0 | 0 | 0 | Canceled | 2019-01-18 | 101 |
| 4809 | City Hotel | 1 | 34 | 2018 | December | 50 | 8 | 0 | 2 | 1 | 0.0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 1 | 0 | A | A | 0 | Non Refund | 19.0 | NaN | 0 | Transient | 90.0 | 0 | 0 | Canceled | 2018-11-17 | 100 |
| 4814 | City Hotel | 1 | 34 | 2019 | December | 50 | 8 | 0 | 2 | 1 | 0.0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 1 | 0 | A | A | 0 | Non Refund | 19.0 | NaN | 0 | Transient | 90.0 | 0 | 0 | Canceled | 2019-11-17 | 100 |
| 4739 | City Hotel | 1 | 28 | 2020 | March | 9 | 2 | 0 | 3 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | NaN | NaN | 0 | Transient | 95.0 | 0 | 0 | Canceled | 2020-02-02 | 99 |
| 4873 | City Hotel | 1 | 38 | 2020 | January | 2 | 14 | 0 | 1 | 1 | 0.0 | 0 | BB | PRT | Corporate | Corporate | 0 | 0 | 0 | A | A | 0 | Non Refund | NaN | 67.0 | 0 | Transient | 75.0 | 0 | 0 | Canceled | 2019-12-07 | 99 |
| 5988 | City Hotel | 1 | 156 | 2020 | April | 17 | 26 | 0 | 3 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 37.0 | NaN | 0 | Transient | 100.0 | 0 | 0 | Canceled | 2019-11-21 | 99 |
| 5221 | City Hotel | 1 | 71 | 2019 | June | 25 | 14 | 0 | 3 | 1 | 0.0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 236.0 | NaN | 0 | Transient | 120.0 | 0 | 0 | Canceled | 2019-04-27 | 89 |